RCG Salsify Products System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
Module | Description |
---|---|
create-salsify-products | Slasify create product request mapping |
get-salsify-product-response | Slasify get product response mapping |
get-salsify-products-list-response | Slasify get products list response mapping |
update-salsify-product | Slasify update product request mapping |
create-salsify-products
Slasify create product request mapping
Source:
./src/main/resources/dwl/create-salsify-products.dwl
Mapping Tables
Maps Salsify Product to CIM Product format
Salsify | CIM | Description | |
---|---|---|---|
id | Product ID | The Product Id | |
Product Name | name | The product name | |
type | type | The Product type | |
Cat_id | productCatalog.'name' | The Product catalog name | |
Category | productCategory.'name' | The Product Category name | |
productSKU | productId | The product Id | |
brand | brand | The product brand | |
externalIdType | externalIdType | The MDM unique Id | |
apiName | auditInfo.createdBy | Identifies the system or user which created the entity | |
createdStamp | auditInfo.createdDate | Timestamp of when the entity was created | |
apiName | auditInfo.updatedBy | Identifies the system or user which last updated the entity | |
lastUpdatedStamp | auditInfo.updatedDate | Timestamp of when the entity was last updated | |
Feature Bullets | description++longDescription | Product tags | |
Consolidated Feature Bullets | description | The Product Description | |
Description | longDescription | The product description | |
size | The ProductSize | The Product Size |
get-salsify-product-response
Slasify get product response mapping
Source:
./src/main/resources/dwl/get-salsify-product-response.dwl
Mapping Tables
Maps Salsify Product to CIM Product format
CIM | Salsify | Description |
---|---|---|
id | externalId | The Mdm Id |
name | productName | The product name |
longDescription | longDescription | Detailed product description |
description | description | Brief product description |
productSKU | productId | The product Id |
brand | brand | The product brand |
productCategory | ProductCategory | The product category Object |
id | productCategoryId | default to null |
name | productCategoryName | The Category Name |
activeFromDate | todays date | default to todays date format "yyyy-MM-dd" |
productCatalog | productCatalog | The product Catalog Object |
id | productCatalogId | Id value default to null |
name | productCatalogName | The Catalog Name |
activeFromDate | todays date | default to todays date format "yyyy-MM-dd" |
priceBookEntry | priceBookEntry | The Price Book Object |
id | priceBookId | Id value default to null |
unitListPrice | fixedAmount | The product fixed price |
isActive | true | default to true |
masterProduct | isVariant | Is it the master product |
externalId | externalId | A unique identifier assigned to the product in another system |
externalIdType | externalIdType | The MDM unique Id |
auditInfo.createdBy | apiName | Identifies the system or user which created the entity |
auditInfo.createdDate | createdStamp | Timestamp of when the entity was created |
auditInfo.updatedBy | apiName | Identifies the system or user which last updated the entity |
auditInfo.updatedDate | lastUpdatedStamp | Timestamp of when the entity was last updated |
primaryProductCategory | primaryProductCategoryId | Product Category |
get-salsify-products-list-response
Slasify get products list response mapping
Source:
./src/main/resources/dwl/get-salsify-products-list-response.dwl
Mapping Tables
Maps Salsify Product to CIM Product format
CIM | Salsify | Description |
---|---|---|
id | externalId | The Mdm Id |
name | productName | The product name |
longDescription | longDescription | Detailed product description |
description | description | Brief product description |
productSKU | productId | The product Id |
brand | brand | The product brand |
productCategory | ProductCategory | The product category Object |
id | productCategoryId | default to null |
name | productCategoryName | The Category Name |
activeFromDate | todays date | default to todays date format "yyyy-MM-dd" |
productCatalog | productCatalog | The product Catalog Object |
id | productCatalogId | Id value default to null |
name | productCatalogName | The Catalog Name |
activeFromDate | todays date | default to todays date format "yyyy-MM-dd" |
priceBookEntry | priceBookEntry | The Price Book Object |
id | priceBookId | Id value default to null |
unitListPrice | fixedAmount | The product fixed price |
isActive | true | default to true |
masterProduct | isVariant | Is it the master product |
externalId | externalId | A unique identifier assigned to the product in another system |
externalIdType | externalIdType | The MDM unique Id |
auditInfo.createdBy | apiName | Identifies the system or user which created the entity |
auditInfo.createdDate | createdStamp | Timestamp of when the entity was created |
auditInfo.updatedBy | apiName | Identifies the system or user which last updated the entity |
auditInfo.updatedDate | lastUpdatedStamp | Timestamp of when the entity was last updated |
primaryProductCategory | primaryProductCategoryId | Product Category |
update-salsify-product
Slasify update product request mapping
Source:
./src/main/resources/dwl/update-salsify-product.dwl
Mapping Tables
Maps Salsify Product to CIM Product format
Salsify | CIM | Description | |
---|---|---|---|
id | Product ID | The Product Id | |
Product Name | name | The product name | |
type | type | The Product type | |
Cat_id | productCatalog.'name' | The Product catalog name | |
Category | productCategory.'name' | The Product Category name | |
productSKU | productId | The product Id | |
brand | brand | The product brand | |
externalIdType | externalIdType | The MDM unique Id | |
apiName | auditInfo.createdBy | Identifies the system or user which created the entity | |
createdStamp | auditInfo.createdDate | Timestamp of when the entity was created | |
apiName | auditInfo.updatedBy | Identifies the system or user which last updated the entity | |
lastUpdatedStamp | auditInfo.updatedDate | Timestamp of when the entity was last updated | |
Feature Bullets | description++longDescription | Product tags | |
Consolidated Feature Bullets | description | The Product Description | |
Description | longDescription | The product description | |
size | The ProductSize | The Product Size |